OpenEdge Development:<br />Progress Dynamics Administration Creating a dumpconfig.txt file

The dumpconfig.txt file provides the processing directions for the Site Data Dump and Load utilities. This file must exist on the PROPATH as sitedatadump/dumpconfig.txt for these utilities to work.

This file is a dump (.d) formatted file that can be imported using the Progress IMPORT statement to load a table of instructions to follow. The file can contain multiple lines that specify all of the fields listed in Table 5–8.

Table 5–8: Field options for creating the dumpconfig.txt file
Field no.	Name	Data type	Description
1	Record Type	`CHARACTER`	The type of record that is being imported. This can be one of: `"I"` for the load program file to run. `"D"` for the dump file to read or write. `"O"` for the dump program file to run. `"S"` for site number.
2	Group Number	`INTEGER`	If Record Type is one of `"I,"` `"D,"` or `"O,"` it is used to group the records for a dump and load set together. If Record Type is `"S,"` it contains the specific site number of the data to dump and load.
3	Filename	`CHARACTER`	Depending on the Record Type, contains a: Relative path name of the dump or load program in the `PROPATH`. Dump filename. A special token or string for the site number.

The following listing shows the default dumpconfig.txt file that ships with the utility software:

dumpconfig.txt
"O" 1 "db/icf/dfd/gsmitout.p" "I" 1 "db/icf/dfd/gsmitin.p" "D" 1 "gsmitout.d" "O" 2 "db/icf/dfd/gsmomout.p" "I" 2 "db/icf/dfd/gsmomin.p" "D" 2 "gsmomout.d" "O" 3 "db/icf/dfd/gsmtmout.p" "I" 3 "db/icf/dfd/gsmtmin.p" "D" 3 "gsmtmout.d" "S" 0 "&S"

The first three lines of this file contain the default data needed to dump and load the gsm_menu_structure_item table.

Line 1 contains information on the dump program. The Record Type is "O" for output, indicating that the line contains information about the dump program itself. The Group Number is 1, and note that all the first three lines have the same Group Number. This number relates the data file with its corresponding dump and load programs. In other words, a dump program, its corresponding load program, and data files must all have the same Group Number. For the dump program, the Filename field contains the program filename, including its relative path, used to dump the data out.

Line 2 contains information on the load program. The Record Type is "I" for input, indicating that the line contains information about the load program. The Group Number is the same as the group number for the corresponding dump program, and the Filename contains the load program filename, including its relative path.

Line 3 contains information about the data file that is the dump file target. The Record Type is "D" for dump file. The Group Number is the same as for the corresponding dump and load program lines, and the Filename is the name of a file that will be written to and read from the first sitedatadump directory in the PROPATH. Note that you can associate more than one dump file with a dump and load program group. The Filename field is used as the key to retrieve the file information. During the process of reading the dumpconfig.txt file, the utilities determine the full path to this file and verify that it is accessible, storing the result in the ttDumpFileLocation.cDumpFilePath field. Because this is a verified path name, all INPUT FROM and OUTPUT TO statements should use the value of this field to determine the correct file to read from or write to.

The next six lines of this file contain dump and load information for the gsm_object_menu_structure and gsm_toolbar_menu_structure tables.

The final line of the file contains a site number record. The Record Type is set to "S" for site number. The Group Number is 0 and the Filename is "&S". This line is a special case. If the Group Number is 0 and the Filename is "&S", the dump utility determines the site number of the currently connected Dynamics Repository and uses that number as the site number for data to be dumped.

If you want to specify a specific site number for which to dump and load the data, instead of using 0, set the Group Number to the value of the site number and set the Filename to the empty string (""). The following line causes the dump program to dump all data for site number 95:

"S" 95 ""

The default dumpconfig.txt file provided in the src/dynamics/db/icf/dfd directory directs these utilities to dump and load data for the gsm_menu_structure_item, gsm_toolbar_menu_structure, and gsm_object_menu_structure tables that were created in a session connected to the current Repository. To make these utilities work, copy the dumpconfig.txt file to a directory named sitedatadump somewhere in the session PROPATH and run the utilities as appropriate.